[dbo].[GroupPerspective]

Property	Value
Row Count	2
Created	10:31:24 AM Tuesday, March 02, 2010
Last Modified	11:40:03 AM Monday, February 20, 2012

Property

Value

Row Count

Created

10:31:24 AM Tuesday, March 02, 2010

Last Modified

11:40:03 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Default
	GroupPerspectiveKey	uniqueidentifier	16
$Indexes IX_GroupPerspective: GroupKey\PerspectiveKey$	GroupKey	uniqueidentifier	16
$Indexes IX_GroupPerspective: GroupKey\PerspectiveKey$	PerspectiveKey	uniqueidentifier	16
	IsDefaultFlag	bit	1	((0))

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

GroupPerspectiveKey

uniqueidentifier

$Indexes IX_GroupPerspective: GroupKey\PerspectiveKey$

GroupKey

uniqueidentifier

$Indexes IX_GroupPerspective: GroupKey\PerspectiveKey$

PerspectiveKey

uniqueidentifier

IsDefaultFlag

bit

((0))

	Name	Columns	Unique
	PK_GroupPerspective	GroupPerspectiveKey
	IX_GroupPerspective	GroupKey, PerspectiveKey

Name

Columns

Unique

PK_GroupPerspective

GroupPerspectiveKey

IX_GroupPerspective

GroupKey, PerspectiveKey

Name	Columns
FK_GroupPerspective_GroupMain	GroupKey->[dbo].[GroupMain].[GroupKey]
FK_GroupPerspective_Perspective	PerspectiveKey->[dbo].[Perspective].[PerspectiveKey]

Name

Columns

FK_GroupPerspective_GroupMain

GroupKey->[dbo].[GroupMain].[GroupKey]

FK_GroupPerspective_Perspective

PerspectiveKey->[dbo].[Perspective].[PerspectiveKey]

SQL Script

CREATE TABLE [dbo].[GroupPerspective]
(
[GroupPerspectiveKey] [uniqueidentifier] NOT NULL,
[GroupKey] [uniqueidentifier] NOT NULL,
[PerspectiveKey] [uniqueidentifier] NOT NULL,
[IsDefaultFlag] [bit] NOT NULL CONSTRAINT [DF_GroupPerspective_IsDefaultFlag] DEFAULT ((0))
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[GroupPerspective] ADD CONSTRAINT [PK_GroupPerspective] PRIMARY KEY CLUSTERED ([GroupPerspectiveKey]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_GroupPerspective] ON [dbo].[GroupPerspective] ([GroupKey], [PerspectiveKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GroupPerspective] ADD CONSTRAINT [FK_GroupPerspective_GroupMain] FOREIGN KEY ([GroupKey]) REFERENCES [dbo].[GroupMain] ([GroupKey])
GO
ALTER TABLE [dbo].[GroupPerspective] ADD CONSTRAINT [FK_GroupPerspective_Perspective] FOREIGN KEY ([PerspectiveKey]) REFERENCES [dbo].[Perspective] ([PerspectiveKey])
GO